IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].tb_top_navigation') AND TYPE in (N'U'))
BEGIN
CREATE TABLE tb_top_navigation
(
    Id INT IDENTITY(1,1) NOT NULL,
    topnavCode varchar(10) not null,
    zh_cn varchar(max) not null default(''),
    zh_tw varchar(max) not null default(''),
    en_us varchar(max) not null default(''),
	Url varchar(max) not null default(''),
	Target varchar(max) not null default(''),
	CreateBy VARCHAR(100),
    CreateDate DATETIME DEFAULT(GETDATE()),
    UpdateBy VARCHAR(100),
    UpdateDate DATETIME,
	CONSTRAINT PK_tb_top_navigation_Id PRIMARY KEY CLUSTERED (Id)
) 
END
GO